/*
 * @description  :一键搜数据
 * @descriptionDetail:一键搜数据
 * @copyright    : 浙江烟草
 * @author       : dw
 * @create       : 2022-10-09 22:21:21
 */
const keySearchInfo = {
  // 创建基础数据表
  createSQL: 'CREATE TABLE IF NOT EXISTS KeySearchVo (' +
        'id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,' +
        'userId VARCHAR ,' +
        'uuid VARCHAR ,' +
        'title VARCHAR ,' +
        'context VARCHAR ,' +
        'type VARCHAR)',
  // 向表插入数据type
  insertSQL: "INSERT INTO KeySearchVo(userId,uuid,title,context,type) " +
        " VALUES(?,?,?,?,?)",
  queryAllSQL: "select * from KeySearchVo",
  queryWhereSQL: "select * from KeySearchVo where userId = ? AND type =?",
  deleteSQL: "delete from KeySearchVo",
  tableName: "KeySearchVo",
  createSQL_H5: {
    name: "KeySearchVo",
    sql:"++id,userId,uuid,title,context,[userId+type],type",
    insertSQL_H5: ["userId","uuid","title","context","type",],
    sqlObj:{
      userId:"",
      uuid: "",
      title:"",
      context:"",
      type:"",
    },
    queryKeys:["userId","type",],
  },
}

module.exports = {
  keySearchInfo,
}
